package com.d6game.purchase.dao;

public class GoodsDao {
	private static final String DB_TABLE_GOODS = "goods";
	private static final String GOODS_ID = "id";
	private static final String GOODS_NAME = "name";
	private static final String GOODS_CODE = "code";
	private static final String GOODS_PRICE = "price";
	private static final String GOODS_COLOR = "color";
	private static final String GOODS_SHOP = "shop";
	private static final String GOODS_COUNT= "count";
	private static final String GOODS_SHOP_TEL= "shoptel";
	private static final String GOODS_PIC1 = "pic1";
	private static final String GOODS_PIC2 = "pic2";
	private static final String GOODS_PIC3 = "pic3";
	public static final String DB_CREATE_TABLE_GOODS =" CREATE TABLE "
			+ DB_TABLE_GOODS +"("
			+ GOODS_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
			+ GOODS_NAME +" TEXT,"
			+ GOODS_CODE +" TEXT,"
			+ GOODS_PRICE +" TEXT,"
			+ GOODS_COLOR +" TEXT,"
			+ GOODS_SHOP +" TEXT,"
			+ GOODS_COUNT +" TEXT,"
			+ GOODS_SHOP_TEL +" TEXT,"
			+ GOODS_PIC1 +" TEXT,"
			+ GOODS_PIC2 +" TEXT,"
			+ GOODS_PIC3 +" TEXT"
			+")";
}
